Monthly ke liye kaise karenge jab har student alag alag date ko join kare yani har student ke liye 30 days ke liye fee collection ke liye banao aur jiski fee summit ho wo column green ho jaye
Kisi student ka fees kis month ka baki kaise gyat kare. Jaise mohan ka fees may ka paid ho compelete show kare, sohan ka fees due ho to unpaid show kate
Hello I want to say you please guide me :- when the student get admission in the college then admission department complete all the detail with giving the id, and then the finance department receive the fees with student with the id which is given by admission department . How we make it.
How to enter fees or instalment in software which should be automatically entered in table.! Like i just use software to update table values I put roll no and all data appear then i make modification in that data and table is updated automatically
साहेब भाई जान अस्सलामुवलैकुम बहुत- बहुत शुक्रिया मैं जानना चाहता हूँ कि जैसे पे स्टेट्स देखने का पेज बनाये हैं उसी तरह फ्रन्ट पेज से स्टुडेंट्स का नाम, कोर्स , फीस डिटेल ईत्यादि आटोमेटिक फ्रन्ट पेज से ही इन्द्र हो जाये|
Series number jo apne liya vo hum koi bhi column me rakh sakte hai kya? Like ager pehle muje name lena ho A column me and B column me ? Serial number ho and B column se search karvana ho to possible hai?
agar mujhe fees me condition lagana ho ki yese students jinhone scheme k under admission liya ho to uski automatically change ho jani chaiye bataye 👍👍👍
kisi ak person ka date wise fee sheet kaise banaye like 18/05/2024se 17/06/2024 tak aur jab vah aage fir plane lena chahe to aage ki fee bhi date wise sheets me ad ho
slam sir ager hum ak student ky bajay pori family (yani ak family ky 3 student ka name or fee ak sath ay ) ky hisab sy banain fee collection to koi video hai asi apki kindly share link
shahab ji thanks for this help can you add something more in it like date of payment of installment and along with it payment receipt printing in same. if you help me in that would be nice of you.
Assalam walaikum sir Agar apne ko school fees kelia create krna to to donation fees rehti hai and other academic fees rehti hai so in sab ko ek saath kaisa kr sakte hai ?
Status main jo function apnay use kia hai wohi same use main kia... But jo cells blanks hain unko bhi wo compare kerta hai nd status completed ajata hai. How to handle it???
As Salaamu Aalaikum Wa Rahmatullauhi Wa Barakatuhu sir, Please tell me that, when I am selecting sheet 1 and naming it as DATA, it is not getting selected only from the column course but not From S.No. column. Please help me sir
Sir g gd evening, in our school three option for fee monthly,installment & one time, so sir class is one cell from 1 to 10th and second column is choice like monthly, installment, one time example class 3rd, one time= fee 20000 is ok and then if (and) formula all ok but status is not showing properly
Sir ham sheet to bnaa leta haa kisi school ka liyaa lekin us sheet ko school ko kesa setting off kar kaa dayee jis trhaa ham represent kar skataa haa uski vedio bnaa kar btaa day or jab bi mera comment parhyr to muja bta day maa itna din tak bnaaa do gaa ku ka ma naw ik school ko sheet bnaa kar deni ha
niece video lakin brother ya working school ya college level ki ha agr ap na uni level per fee ki working karini ha to wo kesy karen gay..jahan fee credit hours k rate k aur admission session k hisab sa alag alag hoti ha.....ma ek institute ma job krta hn agr ap kuch help kar den to ma sample data share kr sakta hn
Sir mein ek institute run karta hu Jisme hum monthly students se fees lete hai Bahut baar students fees nhi dete aur bolte hai ki next month me pay karengye To kya sir kuch aisi sheet bn sakti hai jisme hum alg alg month ki fees auto matic aa jaye aur jo balance last month me nhi diya wo add ho jaye ya student ki fees jitni bnti hai wo usme km pay karta hai maan lo 10000 fees hai par wo 800 deta hai aur ye 200 automatically next month me add ho jaye Sir please mujhe bahut zarort hai aise excel sheet ki aur may b sabhi institute ko pls sir help us
Sir maine aapka video dekha mujhe bahut accha laga.... Maine exact kiya hai... Main ek school me kaam karta hu.. Lekin mujhe serial number se fees search nahi karni hai mujhe student name se fees search karni hai taaki uska naam dalte hi uski sab pending fees aa jaye.... Ye possible hai kya... Maine bahut baar koshish kiyi lekin mujhse nahi ho raha hai... Please help me.. Thanks
Status me if formula Kam nahi Kar Rahi hai sir. Result false aati hai agar fee me formula delete karta ho. Fir result true aati hai lekin me chahata hi begar delete kiye status me result true aaye plz reply sir
@@shahabislam4912 Please bhai naraaz na hona meri baat se, maqsad aap ka dil dukhana nahi tha, mei khud teacher hun iss liyae bol para. Mei chahta hun meray bhai ka kaam sab se ziada chamkay! Goray peechay reh jain Inn Shaa Allah!!
Bahot hi jabardust sir thanks to teache this excel file thanks sir
Sir isme payment mode bhi add karna ho jaise (gpay.imps etc)
very informative knowledge give to us ..thanks sir
Most welcome
Is there anyone here..from school administration employee?
Very very informative and amezing.
Very informative.
جزاک اللہ
Hi sir, jo columns hain unko kaise move kr rhe hai aap ,pls btayen aur ye b btaein k konse button use kr rhe hain ?
Very helpful
Best
Thanks sir.
Assalamualaikum marvellous as useuall welldone
Wonderful project work.
Thank you sir......❤❤❤❤
Very good sir
nice work
Thanks
Very Good effort. really appreciate
So nice of you
Excellent sir
Amazing
Thanks
right work
Excellent sirji
Good sir
Monthly ke liye kaise karenge jab har student alag alag date ko join kare yani har student ke liye 30 days ke liye fee collection ke liye banao aur jiski fee summit ho wo column green ho jaye
Sir if a student have two different courses then how its possible to add two courses fee details on one serial number?
Is mein har student k data k sath graph b bana skty hain? And kesy banaty hain wo isi tarah k wo har studemtk sath us k hisab sy automatic nzr ay?
G bna sakte hen
Kisi student ka fees kis month ka baki kaise gyat kare. Jaise mohan ka fees may ka paid ho compelete show kare, sohan ka fees due ho to unpaid show kate
ruclips.net/video/Fzx-OLgAhAI/видео.html
@@shahabislam4912 thanks
Sirji automatic receipt kaise prepare hogi essay video banav plz
Hello
I want to say you please guide me :- when the student get admission in the college then admission department complete all the detail with giving the id, and then the finance department receive the fees with student with the id which is given by admission department . How we make it.
SUPER GOOD JOB THANK
Can you make attendance and fees management system for sports academy?
awsome sir ji
Nice work.
Really healpful..
One doubt.. please advice on the formula.. For changing the details by inputting Student names not by serial no.
Great dear weldon
Thanks a lot
How to enter fees or instalment in software which should be automatically entered in table.!
Like i just use software to update table values
I put roll no and all data appear then i make modification in that data and table is updated automatically
🤝❤🌹
साहेब भाई जान अस्सलामुवलैकुम बहुत- बहुत शुक्रिया
मैं जानना चाहता हूँ कि जैसे पे स्टेट्स देखने का पेज बनाये हैं उसी तरह फ्रन्ट पेज से स्टुडेंट्स का नाम, कोर्स , फीस डिटेल ईत्यादि आटोमेटिक फ्रन्ट पेज से ही इन्द्र हो जाये|
Thank you sir!!
thank u sir
All the best
ماشاءالله الحمدلله
Series number jo apne liya vo hum koi bhi column me rakh sakte hai kya? Like ager pehle muje name lena ho A column me and B column me ? Serial number ho and B column se search karvana ho to possible hai?
no
agar mujhe fees me condition lagana ho ki yese students jinhone scheme k under admission liya ho to uski automatically change ho jani chaiye bataye 👍👍👍
kisi ak person ka date wise fee sheet kaise banaye like 18/05/2024se 17/06/2024 tak aur jab vah aage fir plane lena chahe to aage ki fee bhi date wise sheets me ad ho
slam sir ager hum ak student ky bajay pori family (yani ak family ky 3 student ka name or fee ak sath ay ) ky hisab sy banain fee collection to koi video hai asi apki kindly share link
shahab ji thanks for this help can you add something more in it like date of payment of installment and along with it payment receipt printing in same.
if you help me in that would be nice of you.
Assalam walaikum sir
Agar apne ko school fees kelia create krna to to donation fees rehti hai and other academic fees rehti hai so in sab ko ek saath kaisa kr sakte hai ?
wonderful presentation. thanks a lot . my sheet 3 is not working . kindly help ... thanx for this valuable video
I think window 10 is used in process that's y🙄
monthly fees...ka banao.... month khatm hone ke baad... automatically... monthly fee add honi chahiye..... please
Status main jo function apnay use kia hai wohi same use main kia... But jo cells blanks hain unko bhi wo compare kerta hai nd status completed ajata hai. How to handle it???
🌹 सीखते रहो, सिखाते रहो 🌹📖📚🏹🌹🔥 राधे राधे🔥ARK🌹🏹🌹🔥ARK 🏹
Nice Job
More Blessings Sir
As Salaamu Aalaikum Wa Rahmatullauhi Wa Barakatuhu sir,
Please tell me that, when I am selecting sheet 1 and naming it as DATA, it is not getting selected only from the column course but not From S.No. column.
Please help me sir
Assalamualaikum bro
Mein ye kehna sahta hu ki
Nursery to 12 th ka kisi students ka status ko kehse check kore
hi informative video,if we abstract all the defaulter at once
i will upload soon
Sir g gd evening, in our school three option for fee monthly,installment & one time, so sir class is one cell from 1 to 10th and second column is choice like monthly, installment, one time example class 3rd, one time= fee 20000 is ok and then if (and) formula all ok but status is not showing properly
Sir ham sheet to bnaa leta haa kisi school ka liyaa lekin us sheet ko school ko kesa setting off kar kaa dayee jis trhaa ham represent kar skataa haa uski vedio bnaa kar btaa day or jab bi mera comment parhyr to muja bta day maa itna din tak bnaaa do gaa ku ka ma naw ik school ko sheet bnaa kar deni ha
Nice video sir par please is file ka download link provided kar do please 🙂
Please show which key is to select desire row constant n change size or font etc..
Ye project as a freelancer damo kam aayega ...
Matlab freelancer pr job ke liye ye project kam aayega
do you have this fees programme saved for us? can you provide a link?
How to aad instalment date
Amazing work sir 😘
niece video lakin brother ya working school ya college level ki ha agr ap na uni level per fee ki working karini ha to wo kesy karen gay..jahan fee credit hours k rate k aur admission session k hisab sa alag alag hoti ha.....ma ek institute ma job krta hn agr ap kuch help kar den to ma sample data share kr sakta hn
Wonderful work Sir👌👌👌
Please tell us how to make TC of students in excel sheet ???
Will upload soon
Siy y list mobile par kese bnay
Will the date keep in changing ? Also want to print individual receipts also
Please attach English subtitles for us who don't understand your language.thank you. Nice video though
Ok next time
Colony monthly charge ki koi excel sheet ho to plz advice or link plz
ruclips.net/video/em5W3lL4XdA/видео.html
Sir ,ek form esa bhi bnao jis me bache ki fee jitni jma ho gai uski entri krne pr sidhi men sheet me chali jaye
sir yeh data ma montly date wise dekhna ho to kya kara
Thank you 💓
You're welcome 😊
What if I have two inputs to lookup the data?
Complete wala Column Blank kaise kare
Sir really badiya h pr jo installment aa rahi h unki date nahi aa rahi ki konsi date ko installment aai h
Sir mein ek institute run karta hu
Jisme hum monthly students se fees lete hai
Bahut baar students fees nhi dete aur bolte hai ki next month me pay karengye
To kya sir kuch aisi sheet bn sakti hai jisme hum alg alg month ki fees auto matic aa jaye aur jo balance last month me nhi diya wo add ho jaye ya student ki fees jitni bnti hai wo usme km pay karta hai maan lo 10000 fees hai par wo 800 deta hai aur ye 200 automatically next month me add ho jaye
Sir please mujhe bahut zarort hai aise excel sheet ki aur may b sabhi institute ko pls sir help us
Ok Upload karoga Jald
Sir maine aapka video dekha mujhe bahut accha laga.... Maine exact kiya hai... Main ek school me kaam karta hu.. Lekin mujhe serial number se fees search nahi karni hai mujhe student name se fees search karni hai taaki uska naam dalte hi uski sab pending fees aa jaye.... Ye possible hai kya... Maine bahut baar koshish kiyi lekin mujhse nahi ho raha hai...
Please help me..
Thanks
Serial ki jaga Naam Rakhlen Hojaega.Serail Select Nhe Karen Phir Table array me
How can I mentioned discounted fees in my master record
Hi Sir hope u will be fine.
Plz Let me know sir How can we search a student by its name?
Type the name instead of the id and select the name by leaving the ID while making the selection
Collam 2 dhalne pr formula nhi lg rha
Office 2007
Sir agar aap mose thoda slow chalayen, to meherbani hogi, khas taur se home insert ye sab par
ar shaikh ok
@@shahabislam4912 thanks
can u provide me that format
डाटा वैलिडेशन में जाते हैं तो दूसरी सीट से सिलेक्ट नहीं होता सर
Dear sir can you make this for me . I can pay the charges whatever it will be...
Status me if formula Kam nahi Kar Rahi hai sir. Result false aati hai agar fee me formula delete karta ho. Fir result true aati hai lekin me chahata hi begar delete kiye status me result true aaye plz reply sir
I want to add date in every installment.....how can i do that?
ruclips.net/video/1846PTovOAI/видео.html
Bhai ye work sheet upload kr do
Circular Refrance kuch aara hai
Can u pls share in description the file u created above.
HI THANKS FOR THE VIDEO ...BUT PLS MY SHEET 3 DOESNT WORK BYOND SERIAL NUMBER 7 WHY PLS?
we have private classes monthly fees manege
Kia ye sheet mil skti hai???
LINK ME CHECK KAREN
@@shahabislam4912 soory bro, i didnt find link. Plzz kindly share link here.
Sir uska name likhne se uska pura data nhi aa sakta
ajega. select table array me name ke column se selection bane lookup value ke baad
please provide sample excel sheet
How to protect this sheet? , so nobody misuse it . Other things are very good
ruclips.net/video/WPDvesCbx7E/видео.html
How to record fee Date vise plz tell me
Sir monthly fee ke liye kaise karu sir??
ruclips.net/channel/UCcOsbNCxgUZMPoHEI1w-1RAsearch?query=monthly%20fee
@@shahabislam4912 thank you sir.. 👍🏻
Do give file link in description in google drive please
I don't understand the language... English plz
Bhai, tutorial zabardast hai lekin spellings par bhi kuch dehan dain, sara impression kharaab ho jaata hai!
g thek he
@@shahabislam4912 Please bhai naraaz na hona meri baat se, maqsad aap ka dil dukhana nahi tha, mei khud teacher hun iss liyae bol para. Mei chahta hun meray bhai ka kaam sab se ziada chamkay! Goray peechay reh jain Inn Shaa Allah!!
slam bhai yea excel file mil skti hai kiya?
20 record se agy show hi nhi krta
english would have been great